package software.literature.db;

public class TableDefinition {
	//the top level's parent_id is -1
public static String[] TABLE_TREE ={"id" ,"name","childrens_id","parent_id"};
public static String[] TABLE_BBG ={"id" ,"data","url","tree_id","type","note_text","note_url"};
public static String[] TABLE_LITERATURE ={"id","name"};
public static String[] TABLE_LITERATURE_REF_BBG ={"id ,ref_items_id"};
public static String   CREATE_TABLE_TREE="CREATE TABLE tree ( id integer PRIMARY KEY autoincrement, name text NOT NULL,childrens_id text,parent_id integer)";
public static String   CREATE_TABLE_BBG="CREATE TABLE bbg ( id integer PRIMARY KEY autoincrement,  data text NOT NULL,url text , tree_id integer,type integer,note_text text,note_url  text)";
public static String   CREATE_TABLE_LITERATURE ="CREATE TABLE  literature (id integer PRIMARY KEY autoincrement ,name text  NOT NULL)";
public static String   CREATE_TABLE_LITERATURE_REF_BBG="CREATE TABLE literature_ref_bbg ( id integer,  ref_items_id integer)";
}   
